﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Collections;
using System.Data.OleDb;
using System.Data;


public partial class admin_Inventory : System.Web.UI.Page
{
    public ArrayList accountarr;
    public ArrayList companyarr;
    OleDbConnection connDB;
    OleDbCommand cmd;
    
    protected void Page_Load(object sender, EventArgs e)
    {
        accountarr = null;
        companyarr = null;
       // connDB = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\FactuSol 2000\\Datos\\0012012.MDB");
        connDB = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\FactuSol 2000\\Datos\\XD12012.MDB");
        cmd = new OleDbCommand();
        string sql = "select * from F_ART";
        //string sql = " SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'";
        cmd.CommandText = sql;
        connDB.Open();
      
        OleDbDataAdapter mainTableAdapter = new OleDbDataAdapter(sql,connDB);
       
       
        DataSet dsinventory = new DataSet();
        try
        {
            mainTableAdapter.Fill(dsinventory, "F_ART");
          

            if (dsinventory != null && dsinventory.Tables[0].Rows.Count > 0) {
                string t1 = dsinventory.Tables[0].Rows[0][1].ToString();
            
            }

            
        }
        catch (Exception ee)
        {
            string error = ee.ToString();
           
        }
        finally{
           if (connDB!= null) connDB.Close();
        }
     
    }
    protected void Button1_Click(object sender, EventArgs e)
    {

    }
}